# coding: utf-8
from sqlalchemy import Column, Float, String
from sqlalchemy.dialects.mysql import INTEGER
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
metadata = Base.metadata


class Menu(Base):
    __tablename__ = 'menu'

    id = Column(INTEGER(11), primary_key=True)
    shopId = Column(String(64))
    shopName = Column(String(255))
    totalPackingFee = Column(Float(10))
    totalPrice = Column(Float(10))
    outOfPacket = Column(Float(10))
    menu = Column(String(2048))


class Shop(Base):
    __tablename__ = 'shop'

    id = Column(INTEGER(11), primary_key=True)
    shopId = Column(String(64))
    shopName = Column(String(128))
    manjian = Column(String(20))
    phone = Column(String(20))
    address = Column(String(128))
    location = Column(String(128))
    shippingFee = Column(Float(10))
    minPrice = Column(Float(10))
    newUserReduceFee = Column(Float(10))
    createTime = Column(String(32))
    updateTime = Column(String(32))
